Samina Issa - Fall 2023
2023-11-29
Youth & Adult Literacy Rates Datasets Link
The data is a CSV from Kaggle. This dataset contains data on literacy rates for youth and adults in various regions and countries. It has two csv files.
The dataset can be used to help policy-makers understand where interventions are needed to improve literacy rates
Growing up, many people in my community, neighborhood and family were not able to read and write. So I wanted to see the literacy rate in recent years and picked it for the project
library(dplyr): using for data manipulation
library(tidyverse): using to transform and better present data
library(ggplot2): using for data visualization and plotting charts
library(plotly): using for creating interactive web-based graphs
## Warning: package 'tidyverse' was built under R version 4.3.2
## Rows: 4,955
## Columns: 7
## $ index <dbl> 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, …
## $ Region <chr> "Central and Southern Asia", "Central and Southern Asi…
## $ Country <chr> "Afghanistan", "Afghanistan", "Afghanistan", "Afghanis…
## $ Year <dbl> 2011, 2011, 2011, 2011, 2011, 2011, 2011, 2011, 2011, …
## $ Age <chr> "15+", "15+", "15+", "15-24", "15-24", "15-24", "25-64…
## $ Gender <chr> "female", "male", "total", "female", "male", "total", …
## $ `Literacy rate` <dbl> 0.1761206, 0.4541710, 0.3174112, 0.3211322, 0.6187907,…
## Rows: 202
## Columns: 9
## $ Country <chr> "Afghanistan", "Albania", "Algeria",…
## $ Region <chr> "SA", "ECA", "MENA", "ECA", "SSA", "…
## $ `Sub-region` <chr> NA, "EECA", NA, "WE", "ESA", NA, NA,…
## $ `Least developed countries (LDC)` <chr> "LDC", NA, NA, NA, "LDC", NA, NA, NA…
## $ `Africa sub-regions` <chr> NA, NA, "Northern Africa", NA, "Sout…
## $ `Africa region` <chr> NA, NA, "All", NA, "All", NA, NA, NA…
## $ Total <dbl> 43, 98, 81, NA, NA, NA, NA, 99, NA, …
## $ Male <dbl> 55, 99, 87, NA, NA, NA, NA, 99, NA, …
## $ Female <dbl> 30, 98, 75, NA, NA, NA, NA, 99, NA, …
| Country Name | Mean Literacy Rate |
|---|---|
| Ukraine | 0.9997176 |
| Uzbekistan | 0.9993926 |
| San Marino | 0.9989923 |
| Latvia | 0.9988922 |
| Estonia | 0.9985737 |
| Lithuania | 0.9982271 |
| Kazakhstan | 0.9973944 |
| Belarus | 0.9973112 |
| Russian Federation | 0.9965556 |
| Cuba | 0.9963581 |
| Country Name | Mean Literacy Rate |
|---|---|
| Chad | 0.2168683 |
| Guinea | 0.2585250 |
| Niger | 0.2780843 |
| Mali | 0.3079387 |
| South Sudan | 0.3079577 |
| Sierra Leone | 0.3331769 |
| Burkina Faso | 0.3341342 |
| Benin | 0.3345030 |
| Afghanistan | 0.3482135 |
| Central African Republic | 0.3705846 |
| Country Name | Year | Mean Literacy Rate |
|---|---|---|
| Angola | 2014 | 0.5893386 |
| Benin | 2012 | 0.3007515 |
| Benin | 2018 | 0.3682544 |
| Botswana | 2013 | 0.7754335 |
| Botswana | 2014 | 0.7835083 |
| Burkina Faso | 2014 | 0.3082644 |
| Burkina Faso | 2018 | 0.3600040 |
| Burundi | 2014 | 0.5563772 |
| Burundi | 2017 | 0.6237482 |
| Cabo Verde | 2012 | 0.7628367 |
| Cabo Verde | 2015 | 0.7807446 |
| Cameroon | 2010 | 0.6236712 |
| Cameroon | 2018 | 0.6985600 |
| Central African Republic | 2010 | 0.3700480 |
| Central African Republic | 2018 | 0.3711212 |
| Chad | 2015 | 0.2350208 |
| Chad | 2016 | 0.1987158 |
| Comoros | 2012 | 0.4412852 |
| Comoros | 2018 | 0.5142472 |
| Congo | 2011 | 0.7851824 |
| Congo | 2018 | 0.7940263 |
| Côte d’Ivoire | 2012 | 0.3834444 |
| Côte d’Ivoire | 2014 | 0.3893085 |
| Côte d’Ivoire | 2018 | 0.4249992 |
| Democratic Republic of the Congo | 2012 | 0.7004237 |
| Democratic Republic of the Congo | 2016 | 0.7174853 |
| Equatorial Guinea | 2010 | 0.8722312 |
| Equatorial Guinea | 2014 | 0.8877333 |
| Eritrea | 2018 | 0.6854249 |
| Ethiopia | 2017 | 0.4558305 |
| Gabon | 2012 | 0.7877476 |
| Gabon | 2018 | 0.8155815 |
| Gambia | 2013 | 0.3713684 |
| Gambia | 2015 | 0.4678795 |
| Ghana | 2010 | 0.6560291 |
| Ghana | 2018 | 0.7443546 |
| Guinea | 2010 | 0.2201764 |
| Guinea | 2014 | 0.2968737 |
| Guinea-Bissau | 2014 | 0.4177127 |
| Kenya | 2014 | 0.7449548 |
| Kenya | 2018 | 0.7704741 |
| Lesotho | 2014 | 0.7198910 |
| Liberia | 2017 | 0.4586232 |
| Madagascar | 2012 | 0.6724460 |
| Madagascar | 2018 | 0.7169571 |
| Malawi | 2010 | 0.5753293 |
| Malawi | 2014 | 0.6122242 |
| Malawi | 2015 | 0.5810756 |
| Mali | 2010 | 0.2839180 |
| Mali | 2011 | 0.3054866 |
| Mali | 2015 | 0.3076377 |
| Mali | 2018 | 0.3347124 |
| Mauritania | 2017 | 0.4928255 |
| Mauritius | 2011 | 0.8591000 |
| Mauritius | 2012 | 0.9179926 |
| Mauritius | 2013 | 0.9152595 |
| Mauritius | 2014 | 0.9250782 |
| Mauritius | 2015 | 0.9274093 |
| Mauritius | 2016 | 0.9319142 |
| Mauritius | 2018 | 0.9008270 |
| Mozambique | 2015 | 0.5147851 |
| Mozambique | 2017 | 0.5561689 |
| Namibia | 2011 | 0.8223099 |
| Namibia | 2018 | 0.8928689 |
| Niger | 2012 | 0.2780843 |
| Nigeria | 2018 | 0.5575417 |
| Rwanda | 2010 | 0.6036011 |
| Rwanda | 2012 | 0.6040566 |
| Rwanda | 2014 | 0.6262772 |
| Rwanda | 2018 | 0.6549838 |
| Sao Tome and Principe | 2012 | 0.8226101 |
| Sao Tome and Principe | 2018 | 0.8597367 |
| Senegal | 2011 | 0.4841566 |
| Senegal | 2013 | 0.3974206 |
| Senegal | 2017 | 0.4831935 |
| Seychelles | 2010 | 0.8993191 |
| Seychelles | 2018 | 0.9278901 |
| Sierra Leone | 2013 | 0.2964802 |
| Sierra Leone | 2018 | 0.3698736 |
| South Africa | 2010 | 0.8818771 |
| South Africa | 2011 | 0.8848133 |
| South Africa | 2012 | 0.8924376 |
| South Africa | 2014 | 0.8993371 |
| South Africa | 2015 | 0.9036035 |
| South Africa | 2017 | 0.8132089 |
| South Sudan | 2018 | 0.3079577 |
| Swaziland | 2010 | 0.7613036 |
| Swaziland | 2018 | 0.8215818 |
| Togo | 2011 | 0.5366900 |
| Togo | 2015 | 0.5746865 |
| Uganda | 2010 | 0.6595080 |
| Uganda | 2012 | 0.6395719 |
| Uganda | 2018 | 0.7025420 |
| United Republic of Tanzania | 2010 | 0.6542276 |
| United Republic of Tanzania | 2012 | 0.7156815 |
| United Republic of Tanzania | 2015 | 0.7138682 |
| Zambia | 2010 | 0.7677941 |
| Zambia | 2018 | 0.8167015 |
| Zimbabwe | 2011 | 0.7955812 |
| Zimbabwe | 2014 | 0.8760068 |
| Country Name | Year | Mean Literacy Rate |
|---|---|---|
| Congo | 2011 | 0.7851824 |
| Mali | 2011 | 0.3054866 |
| Mauritius | 2011 | 0.8591000 |
| Namibia | 2011 | 0.8223099 |
| Senegal | 2011 | 0.4841566 |
| South Africa | 2011 | 0.8848133 |
| Togo | 2011 | 0.5366900 |
| Zimbabwe | 2011 | 0.7955812 |
| Country Name | Year | Mean Literacy Rate |
|---|---|---|
| Botswana | 2013 | 0.7754335 |
| Gambia | 2013 | 0.3713684 |
| Mauritius | 2013 | 0.9152595 |
| Senegal | 2013 | 0.3974206 |
| Sierra Leone | 2013 | 0.2964802 |
| Country Name | Year | Mean Literacy Rate |
|---|---|---|
| Brunei Darussalam | 2011 | 0.8867963 |
| Brunei Darussalam | 2018 | 0.9336902 |
| Cambodia | 2014 | 0.7329373 |
| Cambodia | 2015 | 0.7667038 |
| China | 2010 | 0.9150334 |
| China | 2018 | 0.9506999 |
| China, Macao Special Administrative Region | 2011 | 0.9154869 |
| China, Macao Special Administrative Region | 2016 | 0.9398792 |
| Indonesia | 2011 | 0.8762351 |
| Indonesia | 2014 | 0.9072667 |
| Indonesia | 2015 | 0.9032267 |
| Indonesia | 2016 | 0.9061978 |
| Indonesia | 2018 | 0.9174446 |
| Lao People’s Democratic Republic | 2011 | 0.5440830 |
| Lao People’s Democratic Republic | 2015 | 0.7996727 |
| Malaysia | 2010 | 0.8628319 |
| Malaysia | 2016 | 0.8816744 |
| Mongolia | 2010 | 0.9751818 |
| Mongolia | 2018 | 0.9823008 |
| Myanmar | 2016 | 0.7385578 |
| Philippines | 2013 | 0.9524193 |
| Philippines | 2015 | 0.9745381 |
| Singapore | 2010 | 0.9262641 |
| Singapore | 2011 | 0.9812072 |
| Singapore | 2012 | 0.9793331 |
| Singapore | 2013 | 0.9803722 |
| Singapore | 2014 | 0.9813744 |
| Singapore | 2015 | 0.9503618 |
| Singapore | 2016 | 0.9834127 |
| Singapore | 2017 | 0.9797985 |
| Singapore | 2018 | 0.9808719 |
| Thailand | 2010 | 0.9577023 |
| Thailand | 2013 | 0.9130767 |
| Thailand | 2015 | 0.9125320 |
| Timor-Leste | 2010 | 0.5037682 |
| Timor-Leste | 2018 | 0.5801061 |
| Viet Nam | 2018 | 0.9390292 |
| Region | Male | Female |
|---|---|---|
| Central and Southern Asia | 0.776 | 0.660 |
| Eastern and South-Eastern Asia | 0.915 | 0.851 |
| Europe and Northern America | 0.986 | 0.973 |
| Latin America and the Caribbean | 0.917 | 0.897 |
| Northern Africa and Western Asia | 0.895 | 0.807 |
| Oceania | 0.921 | 0.903 |
| Sub-Saharan Africa | 0.691 | 0.545 |
## # A tibble: 201 × 4
## Country Male Female Difference
## <chr> <dbl> <dbl> <dbl>
## 1 Malta 93 96 -3
## 2 Mongolia 98 99 -1
## 3 Seychelles 95 96 -1
## 4 Uruguay 98 99 -1
## 5 Argentina 99 99 0
## 6 Belarus 100 100 0
## 7 Brazil 93 93 0
## 8 Colombia 95 95 0
## 9 Costa Rica 98 98 0
## 10 Honduras 87 87 0
## # ℹ 191 more rows
## # A tibble: 201 × 4
## Country Male Female Difference
## <chr> <dbl> <dbl> <dbl>
## 1 Afghanistan 55 30 25
## 2 Central African Republic 50 26 24
## 3 Benin 54 31 23
## 4 Nepal 79 60 19
## 5 Morocco 83 65 18
## 6 Nigeria 71 53 18
## 7 Burkina Faso 50 33 17
## 8 Sierra Leone 52 35 17
## 9 India 82 66 16
## 10 Eritrea 84 69 15
## # ℹ 191 more rows